﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Entity;

namespace DAO
{
    public class CountryDAO
    {
        BMS_DatabaseEntities context = new BMS_DatabaseEntities();

         /// <summary>
        /// Lay tat ca danh sach quoc gia
        /// </summary>
        public List<CountryEntity> LoadCountry()
        {

            var query = from c in context.COUNTRY_INFO
                        select new CountryEntity
                        {
                            CountryName = c.COUNTRY_NAME
                        };
            return query.ToList<CountryEntity>();

        }
    }
}
